Last modified time: September 27, 2021
Assumption: 1 kBtu=3.412 KWH
## # A tibble: 54 × 5
## # Groups: YEAR [5]
## YEAR MONTH TOTALKWH Residential_Electric_kBtu Time
## <dbl> <dbl> <dbl> <dbl> <date>
## 1 2017 1 2696632298 9200909401. 2017-01-01
## 2 2017 2 2089405296 7129050870. 2017-02-01
## 3 2017 3 2007875145 6850869995. 2017-03-01
## 4 2017 4 1838107707 6271623496. 2017-04-01
## 5 2017 5 2070656073 7065078521. 2017-05-01
## 6 2017 6 2615607826 8924453902. 2017-06-01
## 7 2017 7 3113124827 10621981910. 2017-07-01
## 8 2017 8 2995761408 10221537924. 2017-08-01
## 9 2017 9 5072659238 17307913320. 2017-09-01
## 10 2017 10 1956786021 6676553904. 2017-10-01
## # … with 44 more rows
Assumption: 1 kBtu=100.00039 THM
## # A tibble: 54 × 5
## # Groups: YEAR [5]
## YEAR MONTH TOTALTHM Residential_Gas_kBtu Time
## <dbl> <dbl> <dbl> <dbl> <date>
## 1 2017 1 332986863 33298816165. 2017-01-01
## 2 2017 2 214756795 21475763255. 2017-02-01
## 3 2017 3 167698331 16769898502. 2017-03-01
## 4 2017 4 128910844 12891134675. 2017-04-01
## 5 2017 5 93587412 9358777699. 2017-05-01
## 6 2017 6 74050205 7405049380. 2017-06-01
## 7 2017 7 70934300 7093457664. 2017-07-01
## 8 2017 8 69535451 6953572219. 2017-08-01
## 9 2017 9 136754090 13675462334. 2017-09-01
## 10 2017 10 92544327 9254468792. 2017-10-01
## # … with 44 more rows
List the electricity and gas consumption of each month from the first quarter of 2017 to the second quarter of 2021 in chronological order.
Take kBtu as the unit for statistics.
Time window: from the first quarter of 2017 to the second quarter of 2021
(The operation steps are almost the same as 1.1-1.6, and replace ‘residential’ with ‘commercial’.)
Time window: from the first quarter of 2017 to the second quarter of 2021
*The World Health Organization (WHO) declared a Public Health Emergency of International Concern on 30 January 2020, and a pandemic on 11 March 2020.
2.2 Comment on observable changes in energy consumption that may be attributable to the COVID-19 pandemic
Comment 1
Comment 2
Comment 3
Comment 4